<?php
require("../../inc/header.php");

/*
		SoftName : EmpireBak Version 2010
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

DoSetDbChar('utf8');
E_D("DROP TABLE IF EXISTS `ecs_order_goods`;");
E_C("CREATE TABLE `ecs_order_goods` (
  `rec_id` mediumint(8) unsigned NOT NULL auto_increment,
  `order_id` mediumint(8) unsigned NOT NULL default '0',
  `goods_id` mediumint(8) unsigned NOT NULL default '0',
  `goods_name` varchar(120) NOT NULL default '',
  `goods_sn` varchar(60) NOT NULL default '',
  `product_id` mediumint(8) unsigned NOT NULL default '0',
  `goods_number` smallint(5) unsigned NOT NULL default '1',
  `market_price` decimal(10,2) NOT NULL default '0.00',
  `goods_price` decimal(10,2) NOT NULL default '0.00',
  `goods_attr` text NOT NULL,
  `send_number` smallint(5) unsigned NOT NULL default '0',
  `is_real` tinyint(1) unsigned NOT NULL default '0',
  `extension_code` varchar(30) NOT NULL default '',
  `parent_id` mediumint(8) unsigned NOT NULL default '0',
  `is_gift` smallint(5) unsigned NOT NULL default '0',
  `goods_attr_id` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`rec_id`),
  KEY `order_id` (`order_id`),
  KEY `goods_id` (`goods_id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8");
E_D("replace into `ecs_order_goods` values('1','1','1','惠普G4-1332TX 14英寸笔记本电脑 （i5-2450M 2G 500G 7450M 1G独显 D刻 无线 摄像头）一流品质，价格公道，放心使用！','ECS000000','0','1','4678.80','2999.00','颜色:黑色 \n版本:WIN7 \n','0','1','','0','0','1,4');");
E_D("replace into `ecs_order_goods` values('2','2','1','惠普G4-1332TX 14英寸笔记本电脑 （i5-2450M 2G 500G 7450M 1G独显 D刻 无线 摄像头）一流品质，价格公道，放心使用！','ECS000000','0','1','4678.80','2999.00','颜色:黑色 \n版本:WIN7 \n','0','1','','0','0','1,4');");
E_D("replace into `ecs_order_goods` values('3','3','24','周生生 黄金(足金)天使系列','ECS000024','0','1','2160.00','200.00','','0','1','','0','0','');");
E_D("replace into `ecs_order_goods` values('4','4','8','清华同方精锐X2 台式电脑（双核E3500 2G 500G DVD 键鼠）带20英寸显示器','ECS000008','0','1','2878.79','2399.00','颜色:黑色 \n版本:60G \n','0','1','','0','0','75,77');");
E_D("replace into `ecs_order_goods` values('5','5','1','惠普G4-1332TX 14英寸笔记本电脑 （i5-2450M 2G 500G 7450M 1G独显 D刻 无线 摄像头）一流品质，价格公道，放心使用！','ECS000000','0','1','4678.80','2999.00','颜色:黑色 \n版本:WINXP \n','0','1','','0','0','1,6');");
E_D("replace into `ecs_order_goods` values('6','6','5','戴尔V260R-376台式电脑（双核i3-2120 2G内存 500G硬盘 1G独立显卡DVD 键鼠 三年上门服务)','ECS000005','0','1','5758.80','4799.00','颜色:黑色 \n版本:60G \n','0','1','','0','0','95,98');");
E_D("replace into `ecs_order_goods` values('7','6','1','惠普G4-1332TX 14英寸笔记本电脑 （i5-2450M 2G 500G 7450M 1G独显 D刻 无线 摄像头）一流品质，价格公道，放心使用！','ECS000000','0','1','4678.80','2999.00','颜色:黑色 \n版本:WIN7 \n','0','1','','0','0','1,4');");

require("../../inc/footer.php");
?>